﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_STATES_DE')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_STATES_DE
	END

GO

CREATE Procedure dbo.PRC_TB_STATES_DE
	(
		@TS_ID int
	)

AS

delete tb_states
where ts_id = @ts_id

GO

GRANT EXEC ON dbo.PRC_TB_STATES_DE TO PUBLIC

GO

